<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'MS Shell Dlg 2'; font-size:10pt; font-weight:400; font-style:normal;">
<p style=" margin-top:3px; margin-bottom:7px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; line-height:32px; background-color:#ffffff;"><span style=" font-family:'oswaldbook,sans-serif'; font-size:x-large; color:#3d3d3d;">Python преобразуется в .xls в .xlsx, включая имя файла и split суффикс</span></p>
<p style=" margin-top:0px; margin-bottom:16px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; line-height:26px; background-color:#ffffff;"><a name="contentaboveads"></a><span style=" font-family:'inherit'; font-size:16px; color:#4f4f4f;">P</span><span style=" font-family:'inherit'; font-size:16px; color:#4f4f4f;">ython преобразуется в .xls в .xlsx, включая имя файла и split суффикс</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">import</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">import</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> pandas </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">as</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> pd</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"><br /></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Этот метод использует XLS к XLSX</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">def</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#dd4a68;">transformat</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">():</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">    </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">global</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> path </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Настраивается как глобальная переменная</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">    path </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">getcwd</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">()</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Получить текущий рабочий путь</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">    </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">file</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">listdir</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">)</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Получить все файлы под текущим путем</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">    </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">for</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> f </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">in</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">file</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">:</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">        file_name_be</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">suff </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">splitext</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">f</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">)</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Сегментировать путь, соответственно, путь к файлу и файловый суффикс</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">        </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">if</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> suff  </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">==</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">'.xls'</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">:</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">            </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">print</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">«Конвертировать {} файлы ...»</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">format</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">f</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">))</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">            data </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> pd</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">DataFrame</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">pd</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">read_excel</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">'\\'</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> f</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">))</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;"># Прочитайте файл XLS</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">            data</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">to_excel</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">'\\'</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> file_name_be </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">«Формат преобразования. XLSX»</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">index </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0184bb;">False</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">)</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; font-style:italic; color:#708090;">#Format преобразование</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">            </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">print</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">Файл '{} был преобразован в {} Сохранить \ n' в каталоге {}</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">format</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">f</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">file_name_be </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">+</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">«Формат преобразования. XLSX»</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">))</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">            </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">   результат: </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be есть </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">  Суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">png</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be есть </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">  Суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">xls</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> Пара</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">XLS Conversion файлов</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">...</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">Файл XLS был преобразован в </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">Формат преобразования</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">Xlsx Сохранить в г</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">:</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">\ Система питания \ Новая папка</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"><br /></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be есть </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">1</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">Формат трансформации суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">xlsx</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be есть </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">23</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">  Суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">ico</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be есть </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">23</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">  Суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">xlsx</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс сборки </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс omcape </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс omcape </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">spec</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс copy1 </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс чтения </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это тестовый суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс TEST2 </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">exe</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс TEST2 </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - это суффикс TEST2 </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">spec</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - транспортный суффикс </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">py</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> File_name_be - __pycache__ суффикс </span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:10px; color:rgba(0,0,0,0.74902);"><br /></p>
<p style=" margin-top:0px; margin-bottom:16px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; line-height:26px;"><span style=" font-family:'inherit'; font-size:16px; color:#4f4f4f;">OS.PATH.SPLITEXT (F) Использование: разделенные имена файлов и файлы</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">import</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">path </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">'G: \ Power System \ Новая папка \ 996 Преобразование .xlsx'</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">a</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">b </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#a67f59;">=</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);"> os</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">splitext</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">path</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">)</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#0077aa;">print</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">(</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">a</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#50a14f;">'\n'</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">,</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">b</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">)</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"><br /></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"><br /></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> результат: </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;">G</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">:</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">\ Силовая система \ новая папка \</span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#986801;">996</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">Преобразование </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#eff0f1;"><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902); background-color:#eff0f1;"> </span><span style=" font-family:'Consolas,Inconsolata,Courier,monospace,PingFang SC,Microsoft YaHei,sans-serif'; font-size:14px; color:#999999;">.</span><span style=" font-family:'Consolas'; font-size:14px; color:rgba(0,0,0,0.74902);">xlsx</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif'; font-size:10px; color:rgba(0,0,0,0.74902);"><br /></p></body></html>